CREATE VIEW [dbo].[vFRParticipantTeamCaptain]
AS
    SELECT f.[ID],
           f.[MEETING],
           f.[TeamID],
           f.[TeamName],
           f.[TeamType],
           f.[TeamGoal],
           a.[ID] AS [CaptainID]
      FROM [dbo].[Name_AlternateId] a
           RIGHT OUTER JOIN [dbo].[Name_FRTeamInformation] f ON a.[AlternateId] = f.[TeamCaptainAlternateId]
           AND a.[IdType] = 'Friendraising'


GO